package com.itheima.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.pojo.CheckItem;
import org.apache.ibatis.annotations.Select;
import org.springframework.web.bind.annotation.PathVariable;

import java.util.List;

/**
 * company: www.abc.com
 * Author: 29746
 * Create Data: 2020/11/10
 */
public interface CheckItemMapper extends BaseMapper<CheckItem> {

    @Select("select ci.* from  t_check_item ci LEFT JOIN t_checkgroup_item cgi on ci.id=cgi.item_id where group_id=#{groupId} and is_delete=0")
    List<CheckItem> findCheckItemByGroupId(@PathVariable("groupId") Long groupId);
}
